Framework / Formulas / Functions / Logical Functions
In This Topic
    Logical Functions
    In This Topic

     

    Syntax Description Example
    AND(b1[, b2, ..., bN]) Returns TRUE if all arguments are TRUE. If any of the arguments is FALSE, the AND function returns FALSE.

    AND(true, false)
    Returns: false

    AND(true, true)
    Returns: true

    NOT(bCondition) Returns TRUE if condition is FALSE. Otherwise, it returns FALSE.

    NOT(true)
    Returns: false

    NOT(false)
    Returns: true

    OR(b1[, b2, ..., bN]) Returns TRUE if any of the arguments is TRUE. Otherwise, it returns FALSE.

    OR(true, false)
    Returns: true

    OR(false, false)
    Returns: false

    XOR(b1[, b2, ..., bN]) Returns TRUE if the arguments differ. Otherwise, it returns FALSE.

    XOR(true, false)
    Returns: true

    XOR(true, true)
    Returns: false

    See Also